﻿using System;using ERP_RORZE_SYSTEM;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_DLL.Product.Base
{
    public class clsConstantsdb
    {
        #region Entities
	public class Entities
    {
        #region QMaterial
        public class ClsDBQMaterial
        {
            public const string Name = "QMaterial";
            public class FieldName
            {
                public const string RecordNo = "RecordNo";
                public const string QuotationID = "QuotationID";
                public const string MPartNo = "MPartNo";
                public const string MaterialID = "MaterialID";
                public const string MaterialType = "MaterialType";
                public const string MaterialPrice = "MaterialPrice";
                public const string Shape = "Shape";
                public const string Thickness = "Thickness";
                public const string Length = "Length";
                public const string Width = "Width";
                public const string Price = "Price";
                public const string Note = "Note";
            }
        }
        #endregion

        #region Qmachine
        public class ClsDBQmachine
        {
            public const string Name = "Qmachine";
            public class FieldName
            {
                public const string RecordNo = "RecordNo";
                public const string InputDate = "InputDate";
                public const string QuotationID = "QuotationID";
                public const string StaffID = "StaffID";
                public const string MPartNo = "MPartNo";
                public const string MachineID = "MachineID";
                public const string OptionID = "OptionID";
                public const string ProTime = "ProTime";
                public const string ClampTime = "ClampTime";
                public const string Note = "Note";
            }
        }
        #endregion

        #region Quotation
        public class ClsDBQuotation
        {
            public const string Name = "Quotation";
            public class FieldName
            {
                public const string QuotationID = "QuotationID";
                public const string Date = "Date";
                public const string CustomerID = "CustomerID";
            }
        }
        #endregion

        #region Expence
        public class ClsDBExpence
        {
            public const string Name = "Expence";
            public class FieldName
            {
                public const string ExpenceID = "ExpenceID";
                public const string Description = "Description";
                public const string LaborExp = "LaborExp";
            }
        }
        #endregion

        #region MonthlyLaborCharge
        public class ClsDBMonthlyLaborCharge
        {
            public const string Name = "MonthlyLaborCharge";
            public class FieldName
            {
                public const string RecordNo = "RecordNo";
                public const string MonthYear = "MonthYear";
                public const string Month = "Month";
                public const string Year = "Year";
                public const string LabCharge = "LabCharge";
            }
        }
        #endregion

        #region MonthlyMachineCharge
        public class ClsDBMonthlyMachineCharge
        {
            public const string Name = "MonthlyMachineCharge";
            public class FieldName
            {
                public const string RecordNo = "RecordNo";
                public const string MonthYear = "MonthYear";
                public const string Month = "Month";
                public const string Year = "Year";
                public const string MachineID = "MachineID";
                public const string MacCharge = "MacCharge";
            }
        }
        #endregion

        #region Expence
        public class ClsDBMonthlyExpence
        {
            public const string Name = "MonthlyExpence";
            public class FieldName
            {
                public const string ExpenceID = "ExpenceID";
                public const string Description = "YearMonth";
                public const string LaborExp = "Amount";
            }
        }
        #endregion

		#region AnodQtyChange
		public class ClsDBAnodQtyChange
		{
			public const string Name = "AnodQtyChange";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string StaffID="StaffID";
				public const string Mono="Mono";
				public const string OKtoNGQty="OKtoNGQty";
				public const string NGtoOKQty="NGtoOKQty";
				public const string note="note";
				public const string finished="finished";
			}
		}
		#endregion

        #region 242_Material
        public class ClsDBMaterial
        {
            public const string Name = "242_Material";
            public class FieldName
            {
                public const string MaterialID = "MaterialID";
                public const string Density = "Density";
                public const string UnitPrice = "UnitPrice";
                public const string Type = "Type";
            }
        }
        #endregion

		#region BusOder
        public class ClsDBBusOder
		{
			public const string Name = "BusOder";
			public class FieldName
			{
				public const string BOderNo="BOderNo";
				public const string date="date";
				public const string planNo="planNo";
				public const string PartID="PartID";
				public const string Qty="Qty";
				public const string Dealine="Dealine";
				public const string RawQty="RawQty";
				public const string HelisertQty="HelisertQty";
				public const string BlastQty="BlastQty";
				public const string MONo="MONo";
				public const string MOQty="MOQty";
				public const string Started="Started";
				public const string Finished="Finished";
				public const string Change="Change";
				public const string ChangeDate="ChangeDate";
				public const string Imported="Imported";
				public const string ImportFrom="ImportFrom";
				public const string Note="Note";
			}
		}
		#endregion

        #region DeadlineCheck
        public class ClsDBDeadlineCheck
        {
            public const string Name = "DeadlineCheck";
            public class FieldName
            {
                public const string BOderNo = "BOderNo";
                public const string PartID = "PartID";
                public const string Qty = "Qty";
                public const string Dealine = "Dealine";
            }
        }
        #endregion

		#region CapCalculation
        public class ClsDBCapCalculation
		{
			public const string Name = "CapCalculation";
			public class FieldName
			{
				public const string ID="ID";
				public const string DeadLine="DeadLine";
				public const string CustomerID="CustomerID";
				public const string MachineID="MachineID";
				public const string Time="Time";
			}
		}
		#endregion

		#region Configure
        public class ClsDBConfigure
		{
			public const string Name = "Configure";
			public class FieldName
			{
				public const string ConfigureID="ConfigureID";
				public const string ConfigureName="ConfigureName";
			}
		}
		#endregion

		#region DailyMachineTime
        public class ClsDBDailyMachineTime
		{
			public const string Name = "DailyMachineTime";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string Shift="Shift";
				public const string MachineID="MachineID";
				public const string WorkID="WorkID";
				public const string Time="Time";
			}
		}
		#endregion

		#region DAnodInsp
        public class ClsDBDAnodInsp
		{
			public const string Name = "DAnodInsp";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string AOKQTY="AOKQTY";
				public const string ANGQTY="ANGQTY";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DataSheet
        public class ClsDBDataSheet
		{
			public const string Name = "DataSheet";
			public class FieldName
			{
				public const string ID="ID";
				public const string PageNo="PageNo";
				public const string date="date";
				public const string code="code";
				public const string StaffRegister="StaffRegister";
				public const string Form="Form";
				public const string Thickness="Thickness";
				public const string Length="Length";
				public const string Width="Width";
				public const string number="number";
				public const string ConfigureName="ConfigureName";
				public const string KDID="KDID";
				public const string RessionID="RessionID";
				public const string cut="cut";
				public const string Handl="Handl";
				public const string MaTrang="MaTrang";
				public const string MaDen="MaDen";
				public const string HairLine="HairLine";
				public const string Seal="Seal";
				public const string Bafu="Bafu";
				public const string Migaky="Migaky";
				public const string Blast30="Blast30";
				public const string Blast60="Blast60";
				public const string WashSA="WashSA";
				public const string Helisert="Helisert";
				public const string SerialClose="SerialClose";
				public const string VacuumPacked="VacuumPacked";
				public const string PalCoat="PalCoat";
				public const string Drawn="Drawn";
				public const string MaBong="MaBong";
				public const string Casiras="Casiras";
				public const string InLuoi="InLuoi";
			}
		}
		#endregion

		#region DBusInsp
        public class ClsDBDBusInsp
		{
			public const string Name = "DBusInsp";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string BusQty="BusQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DF3Store
        public class ClsDBDF3Store
		{
			public const string Name = "DF3Store";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string STOKQTY="STOKQTY";
				public const string STSPQty="STSPQty";
				public const string STNGQty="STNGQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DHandInsp
        public class ClsDBDHandInsp
		{
			public const string Name = "DHandInsp";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string OKQty="OKQty";
				public const string NGQty="NGQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DInspAnod
        public class ClsDBDInspAnod
		{
			public const string Name = "DInspAnod";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string IOKQty="IOKQty";
				public const string INGQty="INGQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DInspF3
        public class ClsDBDInspF3
		{
			public const string Name = "DInspF3";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string F3OKQty="F3OKQty";
				public const string F3SPQty="F3SPQty";
				public const string F3NGQty="F3NGQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DMachineHand
        public class ClsDBDMachineHand
		{
			public const string Name = "DMachineHand";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string StaffID="StaffID";
				public const string MONo="MONo";
				public const string OKQty="OKQty";
				public const string NGQty="NGQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DMBusInsp
        public class ClsDBDMBusInsp
		{
			public const string Name = "DMBusInsp";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string RBusInspQty="RBusInspQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DMHandInsp
        public class ClsDBDMHandInsp
		{
			public const string Name = "DMHandInsp";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string ROKQty="ROKQty";
				public const string RNGQty="RNGQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DMInspBus
        public class ClsDBDMInspBus
		{
			public const string Name = "DMInspBus";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string RInspBusQty="RInspBusQty";
				public const string note="note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region DMInspHand
        public class ClsDBDMInspHand
		{
			public const string Name = "DMInspHand";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string RQty="RQty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region LaborWTS
        public class ClsDBLaborWTS
		{
			public const string Name = "LaborWTS";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string Shift="Shift";
				public const string StaffID="StaffID";
				public const string MachineID="MachineID";
				public const string MONo="MONo";
				public const string OptionID="OptionID";
				public const string WorkID="WorkID";
				public const string time="time";
				public const string OKQty="OKQty";
				public const string NGQty="NGQty";
				public const string ProTime="ProTime";
				public const string Clamptime="Clamptime";
				public const string Note1="Note1";
				public const string Note2="Note2";
				public const string From="From";
				public const string To="To";
				public const string SProTime="SProTime";
				public const string SClampTime="SClampTime";
				public const string TOKQty="TOKQty";
				public const string TNGQty="TNGQty";
			}
		}
		#endregion

		#region MachineWTS
        public class ClsDBMachineWTS
		{
			public const string Name = "MachineWTS";
			public class FieldName
			{
				public const string ID="ID";
				public const string date="date";
				public const string Shift="Shift";
				public const string MachineID="MachineID";
				public const string StaffID="StaffID";
				public const string MONo="MONo";
				public const string OptionID="OptionID";
				public const string WorkID="WorkID";
				public const string Time="Time";
				public const string OKQty="OKQty";
				public const string NGQty="NGQty";
				public const string ProTime="ProTime";
				public const string ClampTime="ClampTime";
				public const string Note1="Note1";
				public const string Note2="Note2";
				public const string From="From";
				public const string to="to";
				public const string SProTime="SProTime";
				public const string SClampTime="SClampTime";
				public const string TOKQty="TOKQty";
				public const string TNGQty="TNGQty";
			}
		}
		#endregion

		#region MaterialForm
        public class ClsDBMaterialForm
		{
			public const string Name = "MaterialForm";
			public class FieldName
			{
				public const string ID="ID";
				public const string MaterialFormID="MaterialFormID";
			}
		}
		#endregion

		#region MO
        public class ClsDBMO
		{
			public const string Name = "MO";
			public class FieldName
			{
				public const string MONo="MONo";
				public const string date="date";
				public const string PartID="PartID";
				public const string MOQty="MOQty";
				public const string DeadLine="DeadLine";
				public const string HelisertQty="HelisertQty";
				public const string BlastQty="BlastQty";
				public const string Started="Started";
				public const string startdate="startdate";
				public const string Finished="Finished";
				public const string Finishdate="Finishdate";
				public const string OKQty="OKQty";
				public const string NGQty="NGQty";
				public const string Imported="Imported";
				public const string Note="Note";
			}
		}
		#endregion

		#region MOgetData
        public class ClsDBMOgetData
		{
			public const string Name = "MOgetData";
			public class FieldName
			{
				public const string ID="ID";
				public const string Oder="Oder";
				public const string PartID="PartID";
				public const string Qty="Qty";
				public const string Dealine="Dealine";
				public const string In_Plan="In_Plan";
				public const string Out_Plan="Out_Plan";
			}
		}
		#endregion

		#region MOMaterial
        public class ClsDBMOMaterial
		{
			public const string Name = "MOMaterial";
			public class FieldName
			{
				public const string ID="ID";
				public const string MONo="MONo";
				public const string PartID="PartID";
				public const string MaterialID="MaterialID";
				public const string MaterialType="MaterialType";
				public const string CutSize="CutSize";
				public const string MaterialPrice="MaterialPrice";
				public const string Shape="Shape";
				public const string Thickness="Thickness";
				public const string lenght="lenght";
				public const string width="width";
				public const string Price="Price";
				public const string Finished="Finished";
				public const string Finishdate="Finishdate";
				public const string Note="Note";
			}
		}
		#endregion

		#region MOOption
        public class ClsDBMOOption
		{
			public const string Name = "MOOption";
			public class FieldName
			{
				public const string ID="ID";
				public const string MONo="MONo";
				public const string PartID="PartID";
				public const string MOQty="MOQty";
				public const string Deadline="Deadline";
				public const string MachineID="MachineID";
				public const string OptionID="OptionID";
				public const string LastOption="LastOption";
				public const string JigID="JigID";
				public const string ProTime="ProTime";
				public const string Finished="Finished";
				public const string Finishdate="Finishdate";
				public const string Shift="Shift";
				public const string Note="Note";
			}
		}
		#endregion

		#region NGCheck
        public class ClsDBNGCheck
		{
			public const string Name = "NGCheck";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string MONo="MONo";
				public const string StaffID="StaffID";
				public const string OptionID="OptionID";
				public const string justment="justment";
				public const string Qty="Qty";
				public const string Note="Note";
				public const string Finished="Finished";
			}
		}
		#endregion

		#region Option
        public class ClsDBOption
		{
			public const string Name = "Option";
			public class FieldName
			{
				public const string OptionID="OptionID";
				public const string OptionName="OptionName";
				public const string Labor="Labor";
			}
		}
		#endregion

		#region OptionData
        public class ClsDBOptionData
		{
			public const string Name = "OptionData";
			public class FieldName
			{
				public const string ID="ID";
				public const string InputDate="InputDate";
				public const string PartID="PartID";
				public const string MachineID="MachineID";
				public const string OptionID="OptionID";
				public const string LastOption="LastOption";
				public const string JigID="JigID";
				public const string ToolQty="ToolQty";
				public const string ProTime="ProTime";
				public const string ClampTime="ClampTime";
				public const string TechDate="TechDate";
				public const string UpdateDay="UpdateDay";
				public const string StaffID="StaffID";
				public const string Note="Note";
				public const string AondNote="AondNote";
				public const string Memo="Memo";
				public const string CLUpdateday="CLUpdateday";
			}
		}
		#endregion

		#region ORDERKH
        public class ClsDBORDERKH
		{
			public const string Name = "ORDERKH";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string MONo="MONo";
			}
		}
		#endregion

		#region Overtime
        public class ClsDBOvertime
		{
			public const string Name = "Overtime";
			public class FieldName
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string StaffID="StaffID";
				public const string Time="Time";
			}
		}
		#endregion

		#region PartData
        public class ClsDBPartData
		{
			public const string Name = "PartData";
			public class FieldName
			{
				public const string ID="ID";
				public const string InputDate="InputDate";
				public const string PartID="PartID";
				public const string MaterialID="MaterialID";
				public const string MaterialType="MaterialType";
				public const string Workpiecesize="Workpiecesize";
				public const string shape="shape";
				public const string Thickness="Thickness";
				public const string width="width";
				public const string lenght="lenght";
				public const string Cut="Cut";
				public const string RawMachine="RawMachine";
				public const string HandFinish="HandFinish";
				public const string HairLine="HairLine";
				public const string WAnod="WAnod";
				public const string BAnod="BAnod";
				public const string Blast30="Blast30";
				public const string Blast60="Blast60";
				public const string Seal="Seal";
				public const string Migaki="Migaki";
				public const string Bafu="Bafu";
				public const string Cleanwave="Cleanwave";
				public const string VacPac="VacPac";
				public const string Helisert="Helisert";
				public const string SerialNo="SerialNo";
				public const string PalCoat="PalCoat";
				public const string Otherpro="Otherpro";
				public const string Price="Price";
				public const string Memo="Memo";
				public const string Note="Note";
				public const string Caciras="Caciras";
				public const string Inside="Inside";
			}
		}
		#endregion

		#region PCPKD
        public class ClsDBPCPKD
		{
			public const string Name = "PCPKD";
			public class FieldName
			{
				public const string ID="ID";
				public const string PType="PType";
			}
		}
		#endregion

		#region WTSTOGA
        public class ClsDBWTSTOGA
		{
			public const string Name = "WTSTOGA";
			public class FieldName 
			{
				public const string ID="ID";
				public const string Date="Date";
				public const string Shift="Shift";
				public const string StaffID="StaffID";
				public const string MachineID="MachineID";
				public const string MONo="MONo";
				public const string WorkID="WorkID";
				public const string Time="Time";
			}
		}
		#endregion

        #region Work
        public class ClsDBWork
        {
            public const string Name = "Work";
            public class FieldName
            {
                public const string WorkID = "WorkID";
                public const string WorkName = "WorkName";
                public const string DirectWork = "DirectWork";
                public const string MachWork = "MachWork";
                public const string MachInDWork = "MachInDWork";
                public const string MachineRun = "MachineRun";
            }
        }
        #endregion

	}
	#endregion
    }
}
